Coronavirus - Statewide Available PPE and Bed Tracking

Statewide Available PPE and Bed Tracking

Note: Data on this page is updated Monday - Friday.

Statewide Available Bed Tracking for COVID-19* 07/29/2020**
	Total Number of Hospital Beds	Hospital Inpatient Beds	Hospital Inpatient Bed Occupied	ICU Beds	ICU Bed Occupied	Negative Pressure Isolation Total	Negative Pressure Isolation Available	Total Ventilators	Available Ventilators	Available Operating Room	Available Adult Med/Surg	Available Burn Care	Available Pediatric	Available Psych.	Total Morgue Capacity	Morgue Available
Region 1	1,736	1,472	1,107	188	169	194	91	207	160	37	194	0	18	39	43	23
Region 2N	5,079	4,826	3,695	512	431	332	161	533	363	76	390	0	54	81	178	118
Region 2S	7,352	6,598	5,245	927	735	483	125	1,127	640	105	440	11	97	33	288	174
Region 3	3,291	2,696	2,090	423	341	266	121	313	213	79	749	1	90	29	73	66
Region 5	2,104	1,486	1,199	202	127	260	124	232	191	65	238	3	51	71	34	29
Region 6	2,734	2,389	1,662	373	290	231	75	396	320	84	356	13	45	13	108	81
Region 7	1,011	985	604	198	115	177	122	98	87	38	209	0	20	6	30	23
Region 8	704	581	276	79	51	101	74	96	87	37	224	0	21	13	31	31
Total	24,011	21,033	15,878	2,902	2,259	2,044	893	3,002	2,061	521	2,800	28	396	285	785	545

*85% response rate
** Data is preliminary and subject to change
.

**COVID-19 Metrics 07/30/2020**
HCC Region	Region 1	Region 2 North	Region 2 South	Region 3	Region 5	Region 6	Region 7	Region 8	Total
# of ED Discharges	118	103	139	96	17	81	26	49	629
# In Critical Care	15	58	76	47	12	16	4	0	228
# on Ventilators	13	50	63	13	7	6	1	0	153
# of Inpatients	27	124	137	64	45	38	3	0	438

Statewide Hospital Available PPE Tracking for COVID-19* 07/29/2020**
	CAPRs	Coveralls	Elastomeric Respirator	Elastomeric Respirator Filters	Face Shields	Gloves	Goggles	N95 Respirator Masks	PAPR Batteries	PAPR Filters	PAPRs	Surgical Gowns	Surgical Isolation Gowns	Surgical Masks/ Facemasks
Region 1	50	47,752	97	35	132,804	942,846	4,804	166,858	214	411	139	21,168	184,939	913,792
Region 2N	185	9,607	24	73	83,606	6,955,713	19,155	211,570	356	730	426	75,095	219,845	469,373
Region 2S	112	7,321	44	1,875	183,025	2,986,548	13,018	321,311	866	1,328	457	37,630	345,356	1,119,969
Region 3	248	3,925	28	52	99,798	6,657,770	38,469	189,434	244	406	167	27,395	450,071	1,200,290
Region 5	154	1,907	23	106	26,357	1,294,676	9,614	46,400	268	330	208	14,366	55,513	114,008
Region 6	77	1,709	214	436	104,242	16,428,022	35,739	441,052	690	1,217	669	72,129	71,737	6,254,335
Region 7	46	2,928	0	0	79,088	5,624,006	9,528	45,373	384	438	303	28,537	17,478	1,381,899
Region 8	4	2,356	72	204	31,633	2,276,731	992	88,483	167	396	170	12,009	61,473	378,156
Total	876	77,505	502	2,781	740,553	43,166,312	131,319	1,510,481	3,189	5,256	2,539	288,329	1,406,412	1,831,822

*77% Reporting
**Data is preliminary and subject to change

Data is self-reported by hospitals daily to the EM Resource System per MDHHS Director Robert Gordon’s Emergency Order.
Changes in inventory numbers have likely occurred since reporting was completed.
This information will be updated daily by 7 p.m.
Information about Healthcare Coalition Regions is available on the MDHHS website.

Region1 – Clinton, Eaton, Gratiot, Hillsdale, Ingham, Jackson, Lenawee, Livingston and Shiawassee counties.
Region 2S – City of Detroit and Monroe, Washtenaw and Wayne counties.
Region 2N - Macomb, Oakland and St. Clair counties.
Region 3 - Saginaw, Alcona, Iosco, Ogemaw, Arenac, Gladwin, Midland, Bay, Genesee, Tuscola, Lapeer, Sanilac and Huron counties.
Region 5 - Allegan, Barry, Calhoun, Branch, St. Joseph, Cass, Berrien, Van Buren and Kalamazoo counties.
Region 6 - Clare, Ionia, Isabella, Kent, Lake, Mason, Mecosta, Montcalm, Muskegon, Newaygo, Oceana, Osceola and Ottawa counties.
Region 7 - Manistee, Wexford, Missaukee, Roscommon, Benzie, Leelanau, Grand Traverse, Kalkaska, Crawford, Oscoda, Antrim, Otsego, Montmorency, Alpena, Presque Ilse, Cheboygan, Emmet and Charlevoix counties.
Region 8 - Chippewa, Mackinac, Luce, Schoolcraft, Delta, Alger, Marquette, Dickinson, Menominee, Baraga, Iron, Gogebic, Ontonagon, Houghton and Keweenaw counties.

**PPE Days On Hand as of 07/30/2020**
Health System/Hospital	N95 Masks	Surgical Masks	Surgical Gowns	Shields	Gloves	System/Independent
Ascension	21+ days	15-21 days	21+ days	21+ days	21+ days	Health System
Aspirus	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Baraga County Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Beaumont	7-14 days	0-6 days	7-14 days	21+ days	7-14 days	Health System
Bronson	21+ days	0-6 days	21+ days	21+ days	7-14 days	Health System
Covenant	21+ days	21+ days	21+ days	21+ days	7-14 days	Health System
Deckerville Community Hospital	21+ days	15-21 days	21+ days	21+ days	21+ days	Independent
Detroit Medical Center	21+ days	7-14 days	21+ days	21+ days	7-14 days	Health System
Dickinson Memorial Health Care System	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Eaton Rapids Medical Center	21+ days	15-21 days	15-21 days	21+ days	21+ days	Independent
Harbor Beach Community Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Helen Newberry Joy Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Henry Ford Health System	21+ days	15-21 days	21+ days	21+ days	0-6 days	Health System
Hills and Dales General Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Hillsdale Hospital	21+ days	21+ days	21+ days	15-21 days	21+ days	Independent
Holland Community Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Hurley Medical Center	21+ days	0-6 days	0-6 days	21+ days	21+ days	Health System
Kalkaska Memorial Health Center	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Mackinac Straits Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Marlette Regional Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
McKenzie Memorial Hospital	21+ days	21+ days	15-21 days	21+ days	21+ days	Independent
McLaren	21+ days	15-21 days	21+ days	21+ days	21+ days	Health System
Memorial Healthcare	15-21 days	15-21 days	7-14 days	21+ days	15-21 days	Independent
Metro	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Michigan Medicine	21+ days	7-14 days	0-6 days	0-6 days	0-6 days	Health System
MidMichigan Health	15-21 days	0-6 days	21+ days	21+ days	15-21 days	Health System
Munising Memorial Hospital	21+ days	7-14 days	21+ days	21+ days	21+ days	Independent
Munson Health System	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
North Ottawa Community Hosp	21+ days	7-14 days	21+ days	21+ days	21+ days	Independent
OSF St. Francis Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Oaklawn Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Pontiac General Hospital	21+ days	0-6 days	21+ days	21+ days	21+ days	Independent
Prime Health	21+ days	7-14 days	21+ days	21+ days	0-6 days	Health System
ProMedica	21+ days	7-14 days	15-21 days	21+ days	7-14 days	Health System
Scheurer Hospital	21+ days	0-6 days	21+ days	21+ days	21+ days	Independent
Schoolcraft Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Sheridan Community Hospital	21+ days	0-6 days	21+ days	21+ days	7-14 days	Independent
Sparrow Health System	21+ days	21+ days	21+ days	21+ days	0-6 days	Health System
Spectrum	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Straith Hospital	21+ days	7-14 days	21+ days	21+ days	21+ days	Independent
Sturgis Hospital	21+ days	15-21 days	21+ days	21+ days	21+ days	Independent
Three Rivers Health	0-6 days	15-21 days	21+ days	21+ days	21+ days	Independent
Trinity	21+ days	7-14 days	21+ days	21+ days	7-14 days	Health System
UP Health	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
War Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent

**Patient Census as of 07/30/2020**
Health System/Hospital	COVID-19 Patients	COVID-19 Patients in ICU	Bed Occupancy
Ascension	97	29	79%
Aspirus	0	0	45%
Baraga County Memorial Hospital	0	0	47%
Beaumont	114	52	78%
Bronson	22	6	75%
Covenant	21	10	82%
Deckerville Community Hospital	0	0	8%
Detroit Medical Center	41	31	82%
Dickinson Memorial Health Care System	0	0	43%
Eaton Rapids Medical Center	0	0	40%
Harbor Beach Community Hospital	0	0	0%
Helen Newberry Joy Hospital	0	0	16%
Henry Ford Health System	150	32	74%
Hills and Dales General Hospital	0	0	32%
Hillsdale Hospital	5	2	40%
Holland Community Hospital	2	0	57%
Hurley Medical Center	3	3	94%
Kalkaska Memorial Health Center	0	0	0%
Mackinac Straits Hospital	0	0	55%
Marlette Regional Hospital	0	0	16%
McKenzie Memorial Hospital	0	0	8%
McLaren	78	24	76%
Memorial Healthcare	1	1	59%
Metro	2	0	58%
Michigan Medicine	16	4	89%
MidMichigan Health	9	2	62%
Munising Memorial Hospital	0	0	7%
Munson Health System	6	6	65%
North Ottawa Community Hosp	0	0	23%
Oaklawn Hospital	0	0	32%
OSF St. Francis Hospital	0	0	18%
Pontiac General Hospital	0	0	12%
Prime Health	17	6	67%
ProMedica	5	2	66%
Scheurer Hospital	0	0	39%
Schoolcraft Memorial Hospital	0	0	42%
Sheridan Community Hospital	0	0	5%
Sparrow Health System	24	2	77%
Spectrum	44	10	65%
Straith Hospital	0	0	42%
Sturgis Hospital	5	0	88%
Three Rivers Health	0	0	43%
Trinity	65	16	82%
UP Health	0	0	63%
War Memorial Hospital	0	0	32%
Grand Total	727	238	74%

The information is aggregated by health system for those hospitals that are part of a health system. This is because systems are centrally tracking and distributing personal protection equipment (PPE) amongst their various facilities and looking at patient surge and load from a system perspective. Non-system hospitals are identified as individual hospitals.The data reflects the status in health systems and hospitals 48 hours prior to the time that the data was posted to this website.This information has been compiled by the Michigan Health & Hospital Association (MHA) on behalf of the Michigan Department of Health & Human Services (MDHHS). The data is from the state of Michigan's EMResource data system. Hospitals are required to enter data into EMResource. The data reflects the status in the hospital or health system from the previous 48 hour period.General Information:Tableau Dashboard of Health System/Hospital Data

Data Dictionary:

PPE Days on Hand - This is a calculation based on a number of factors including the amount of PPE, the number of COVID-19 patients, beds, industry standard usage and conservation techniques.

COVID-19 Patients – Confirmed positive patients, as well as patients who are currently pending and under investigation (PUI). This includes COVID-19 patients in the ICU.

COVID-19 Patients in ICU - Confirmed postive patients and suspected patients in intensive care unit (ICU).

Bed Occupancy - The percentage of staffed inpatient beds occupied by any patient regardless of COVID-19 status. This includes surge or overlow beds.

Navigation:

There are three data tabs that display information:

Dashboard - PPE status and Patient Census for a specific health system or hospital

Patient Census - Patient census for all health systems/hospitals in Michigan

PPE - Personal protective equipment status for all health systems/hospitals in Michigan